BenchMarksql 6.0 安装与部署

1 背景知识

本文主要介绍如何从源码编译和安装 BenchMarksql 6.0。

2 环境准备

2.1 JAVA 开发环境

#root>
dnf install java-1.8.0-openjdk-devel -y

2.2 Maven 工具

#root>
dnf install maven -y 

3 BenchMarksql 6.0 源码和编译

3.1 BenchMarksql 6.0 源码下载

su - postgres 
#postgre>
cd /soft
git clone https://github.com/pgsql-io/benchmarksql.git

Cloning into 'benchmarksql'...
remote: Enumerating objects: 2593, done.
remote: Counting objects: 100% (169/169), done.
remote: Compressing objects: 100% (75/75), done.
remote: Total 2593 (delta 80), reused 147 (delta 74), pack-reused 2424
Receiving objects: 100% (2593/2593), 6.48 MiB | 1.86 MiB/s, done.
Resolving deltas: 100% (1475/1475), done.

3.2 BenchMarksql 6.0 源码编译

#postgres>
cd /soft/benchmarksql
mvn

4 BenchMarsql WEB 服务配置

4.1 安装 Python 依赖

#root>
pip3 install pip --upgrade
cd /soft/benchmarksql/target/run/
pip3 install -r requirements.txt 

4.2 启动 BenchMarsql WEB 服务

su - postgres 
#postgres>
cd /soft/benchmarksql/target/run
python3 ./FlaskService/main.py  > benchmarksql_web.log 2>&1 &

启动的登录地址为 http://192.168.10.155:5000。

5 BenchMarksql 打包下载

#postgres>
cd /soft
tar -zcf BenchMarksql_6.0.tar.gz benchmarksql

6 参考链接

Building - BenchmarkSQL